--- title: Application data model summary: Cross-library database table inventory for LegalMaintenance, grouped by business domain. status: draft owner: SAIF Doc Gen last_reviewed: 2026-08-21 --- # Application data model This page documents the cross-library database table inventory for LegalMaintenance, grouped by business domain. ## Attorneystaff domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | ATTORNEY_PROFILE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Attorney bio/profile data, surfaced via `frmAttorneyProfile` | | ATTORNEY_SCHEDULE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Attorney schedule/availability data | | ATTORNEY_SCHEDULE_TYPE_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Reference codes for schedule types | | ATTORNEY_WORKER_ASSIGNMENT | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Attorney-to-claim/worker assignment records | | ATTORNEY_CONFLICT | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Attorney conflict-of-interest tracking, tied to assignment | | ATTORNEY_POLICY_ASSIGNMENT | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Attorney-to-policy assignment records | | ATTORNEY_TYPE_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Reference codes for attorney type | | ADP_EMPLOYEE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Employee/staff reference data used by attorney maintenance | ## Hearing location domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | HEARING_LOCATION | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Hearing location records, surfaced via `frmHearingLocation` | | HEARING_LOCATION_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Reference codes for hearing locations | | DURATION_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Reference codes for hearing durations | ## Legal person other firm domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | LEGAL_PERSON | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Legal person records, surfaced via `frmLegalPerson` | | LEGAL_PERSON_TYPE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Legal person type reference data | | LEGAL_PERSON_TYPE_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Legal person type codes | | OTHER_FIRM | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Other-firm records, surfaced via `frmOtherFirms` | | OTHER_FIRM_TYPE_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Other-firm type reference codes | ## Legal casehearing domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | CASE_COST | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Legal case cost data, consumed transitively via LegalNet managers, not directly by LegalMaintenance screens | | CASE_STATUS_HISTORY | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R | Legal case status history | | CASE_STATUS_CODE | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Legal case status reference codes | | OUTCOME_* | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | Legal case outcome reference tables | | LEGAL_CASE_* | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Legal case core tables | | LEGAL_FILE_LOCATION* | [unqualified]** | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | C/R/U | Legal case file location tables | | LEGAL.VW_CASES | LEGAL | [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) | R | View aggregating legal case data | ## Claimbenefit domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | CL_1502_DCBS_TRANSFER | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Reachable indirectly through claim context/security | | CL_BENEFIT_PAYMENT | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim benefit payment records | | CL_BENEFIT_SCHEDULE | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim benefit schedule records | | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim employee work address records | | CL_CLAIM_WORK_RELEASE_STATUS | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim work release status records | | CL_CLAIM_WORK_STATUS | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim work status records | | CL_FEDERAL_AWARD | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim federal award records | | CL_INJURY_CLAIM | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Injury claim core records | | CL_PPD_* | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Permanent partial disability tables | | CL_RESERVE_* | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Claim reserve tables | | CL_WORKER_INJURED_BODY_PART | [unqualified]** | [SAIF.Business.Claim](../libraries/saif-business-claim/overview.md) | R | Injured body part records | ## Task domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | TASK | [unqualified]** | [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) | C/R/U | Task records raised as a side effect of assignment workflows | | TASK_ACTION_CODE | [unqualified]** | [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) | R | Task action reference codes | | TASK_CATEGORY_CODE | [unqualified]** | [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) | R | Task category reference codes | | TASK_PRIORITY_CODE | [unqualified]** | [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) | R | Task priority reference codes | | TASK_SOURCE_CODE | [unqualified]** | [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) | R | Task source reference codes | | LEGACY_TASK_CODE | [unqualified]** | [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) | R | Legacy task code cross-reference | ## Policy domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | POLICY | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Policy core record, consumed for legal-context lookups | | POLICY_PERIOD | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Policy period records | | POLICY_PERIOD_NON_WCIS | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Policy period records for non-WCIS policies | | ENDORSEMENT | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Policy endorsement records | | PREM_HIST_SUMMARY | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Premium history summary | | HAZARD_GROUP | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Hazard group reference data | | MANUAL_CLASS_TYPE_CODE | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Manual class type reference codes | | BENEFIT_JURISDICTION_CODE | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Benefit jurisdiction reference codes | | DUAL | [unqualified]** | [SAIF.Business.Policy](../libraries/saif-business-policy/overview.md) | R | Dual-coverage policy reference data | ## Provider domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | PROVIDER | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider core records, consumed for legal correspondence targets | | PROVIDER_TAX_ID | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider tax ID records | | PROVIDER_LOCATION | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider location records | | PROVIDER_ADDRESS | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider address records | | PROVIDER_INELIG_PERIOD | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider ineligibility period records | | PROVIDER_RELATIONSHIP | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider relationship records | | PROVIDER_TYPE_CODE | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider type reference codes | | PROVIDER_DCBS_COST_CHARGE | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider DCBS cost charge records | | MCO_PROVIDER | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | MCO provider records | | PROVIDER_SERVICE | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider service records | | PROVIDER_SERVICE_CODE | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider service reference codes | | PROVIDER_SERVICE_CONTRACT | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider service contract records | | PROVIDER_IDENTITY | [unqualified]** | [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) | R | Provider identity records | ## Batchscheduling domain | Table | Schema | Owning library | CRUD | Notes | | --- | --- | --- | --- | --- | | JOB_QUEUE | [unqualified]** | [SAIF.Services.Appworx](../libraries/saif-services-appworx/overview.md) | C | Accessed only via the `submit_appworx_job` stored procedure (proc-side only) | [unqualified]**: The owning-library analyses did not capture explicit Oracle schema-owner qualifiers for these tables; treat the schema as unknown until verified against source SQL qualifiers. ## Related documentation - [Index](index.md) - [Overview](overview.md) - [Architecture](architecture.md) - [Dependencies](dependencies.md) - [Configuration](configuration.md) - [Operations and processes](operations-processes.md) - [Business rules](business-rules.md) - [Security and authorization](security-authorization.md) - [Tech debt](tech-debt.md) > **Note:** Statements marked with `**` could not be confirmed; treat as unknown > until verified. ## Sources - LegalMaintenance web application (LegalMaintenance/*.aspx.vb) - [SAIF.Business.Claim.Legal](../libraries/saif-business-claim-legal/overview.md) - [SAIF.Business.Tasks](../libraries/saif-business-tasks/overview.md) - [SAIF.Business.View.Policy](../libraries/saif-business-view-policy/overview.md) - [SAIF.Business.View.Provider](../libraries/saif-business-view-provider/overview.md) - [SAIF.Services.Appworx](../libraries/saif-services-appworx/overview.md)